﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MaxLeaf.Platform.Contract;
using MaxLeaf.Platform.DataContract;
using CommonsLib.DB;
using System.Transactions;
using System.Data.SqlClient;
using System.Data.Common;
using System.Diagnostics;
using CommonsLib.Settings;
using System.Data;

using System.Security.Cryptography;
using MaxLeaf.Platform.Functions;
using MaxLeaf.Platform.Commons;

namespace MaxLeaf.Platform.DALImplementation
{
    public class mInputTypeDAL : BaseDAL 
    {




        public int GetRecvTypeId(DBAccess dbcon, int intCompanyID)
        {
            string strSql = "select top 1 recid from  mInputType where companyid=@companyid and SysType=0 and is_delete=0  ";
            using (DbDataReader rdr = dbcon.GetDataFirstRow(strSql, new SqlParameter[] { new SqlParameter("companyid", intCompanyID) }))
            {
                rdr.Read();
                return rdr.GetInt32(0);
            }
        }
    }
}
